convert dd-mm-yyyy to yyyy-mm-dd in mysql php

74

php convert date from dd/mm/yyyy to yyyy-mm-dd -

$date = DateTime::createFromFormat('d/m/Y', "24/04/2012");
echo $date->format('Y-m-d');

convert dd/mm/yyyy to yyyy-mm-dd in mysql php -

$var = '20/04/2012';
$date = str_replace('/', '-', $var);
echo date('Y-m-d', strtotime($date));

Comments

Submit
0 Comments